package com.rt.easyjava.base.modules.timerjob.mapper;

import com.rt.easyjava.base.modules.timerjob.mapper.base.TmptTimerMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 *  Mapper 接口
 * @author wuxiaoyong
 * @since 2020-06-01
 */

@Mapper
public interface ProcedureMapper extends TmptTimerMapper {
    // call event_daily_report('20200722')
    @Select("call ${name}()")
    String call0 (String name);

    @Select("call ${name}(#{p1})")
    String call1 (String name, String p1 );

    @Select("call ${name}(#{p1},#{p2})")
    String call2 (String name, String p1, String p2 );

    @Select("call ${name}(#{p1},#{p2},#{p3})")
    String call3 (String name, String p1, String p2, String p3 );

    @Select("call ${name}(#{p1},#{p2},#{p3},#{p4})")
    String call4 (String name, String p1, String p2, String p3, String p4 );

    @Select("call ${name}(#{p1},#{p2},#{p3},#{p4},#{p5})")
    String call5 (String name, String p1, String p2, String p3, String p4, String p5 );
}
